Pipeline/Cable Table Formats

Using the Excel format allows you to easily import a large quantity of data for pipelines and cables, including origin and terminus. Because of the number of columns in these tables, the following examples are presented with multiple breaks.

Pipelines

The required fields – Line ID, Diameter, Pipe Class, and Commodity – are the standard value types of the pipeline list. The remaining columns (excluding Origin and Terminus) are the attributes normally changed in the Pipeline Editor, but saved in the *.rpl process file.

For this example, the attributes have been ordered to match the layout of the Pipeline Editor dialog.

PW Data Starts
PW Class:	Pipelines
Line ID	Diameter	Origin	Terminus
10-123	3.0	80-122	80-C-130/H
40-128	6.0	(HEADER 80-E-160/TA 80-E-170/TA	OPC-19/MS
60-100	4.0	OPC-3/MS	80T-100/A

Unit ID	Description	Priority	Temperature	Pipe Class
10		60		CA11
40			COLD	NA18
60				A2A

Commodity	Insulation Code	Thickness	CAD Level	Fluid Phase
PL		0.0
PV	IH	1.0
CWR		0.0	cooling

Material	Pipeway Level	PW Level Required	Rating
	ANY		600
		T

Temperature	User Category	User Suction P	<pipeline user defined attributes>
0.0
	PIPEWAY
		NO
			PW Data Ends

Cables

Electrical cables only require values for the Cable ID and Specification; however, any of the attribute values normally edited in the Cable Editor can be imported in the cable table of the Excel file:

PW Data Starts
PW Class:	Cables
Cable ID	Origin	Terminus	Specification	Description	Priority
cab-1	48-P-1/E	48-P-3/E	CA314

Voltage	Glands	Diameter	Area	Weight	Cost Factor	Spacing Index	CAD Level

Pipeway Level	PW Level Required	User Category	<cable user defined attributes>

			PW Data Ends